*** Settings ***
Documentation    TC12-Project Status Check FCL
Resource    ../../Keywords/Common_Head.robot
Force Tags    P3
Metadata    Author    Joe
Metadata    ID    6855118


*** Test Cases ***
TC12-Project Status Check FCL
    Step 1 User Goes To Basic Data Management Tender List
    Step 2 User Goes To Pricing Collaboration Pricing Project
    Step 3 Check The Status Of This New Created Project
    Step 4 User Select The Row Which Project Name Is 20240815 FCL
    Step 5 Click On Upload Button Select The Attachment To Upload
    Step 6 User Select Map Columns Like That
    Step 7 Close This Dialog
    Step 8 User Select The Row Which Project Name Is 20240815 FCL2
    Step 9 User Select The Row Which Project Name Is 20240815 FCL3
    Step 10 User Select The Row Which Project Name Is 20240815 FCL4
    Step 11 User Select The Row Which Project Name Is 20240815 FCL5
    Step 12 User Select The Row Which Project Name Is 20240815 FCL6
    Step 13 User Select The Row Which Project Name Is 20240815 FCL7
    Step 14 User Select The Row Which Project Name Is 20240815 FCL8
    Step 15 User Select The Row Which Project Name Is 20240815 FCL9
    Step 16 User Select The Row Which Project Name Is 20240815 FCL10
    Step 17 User Select The Row Which Project Name Is 20240815 FCL11
    Step 18 User Select The Row Which Project Name Is 20240815 FCL12
    Step 19 User Select The Row Which Project Name Is 20240815 FCL13
    Step 20 User Click On Data Cleaning Of This Project And Then
    Step 21 User Goes To Basic Data Management Tender List



*** Keywords ***
Step ${step} User Goes To Basic Data Management Tender List
    #************************Step 1******************************
    #  Do:
    #      User goes to Basic Data Management Tender List
    #      Click Create button
    #      Input with following attributes
    #      Tender ID some numbers such as 202408151435001 you can
    #     input with current datetime and some random number to
    #     avoid duplicate validation
    #      Tender Title some value such as Regression Test by
    #     Wendy001
    #      Customer 815 Miele
    #      Mode select all
    #      Level Global
    #      Click on Save button
    #  Expected:
    #      Created successfully with the message Tender has been
    #     added
    #************************************************************
    ${G_TENDERID}    Generate Tender ID
    Set Suite Variable     ${G_TENDERID}
    Login Space
    Create Tender    ${G_TENDERID}    Regress    815    true    true    true

Step ${step} User Goes To Pricing Collaboration Pricing Project
    #************************Step 2******************************
    #  Do:
    #      User goes to Pricing Collaboration Pricing Project
    #      User clicks Create Project button
    #      Input following attributes
    #      Tender ID 20240815 Regression
    #      Mode FCL
    #      Deadline to TM current date 10 day
    #      Rate Validity From current date
    #      Rate Validity To current date 100 day
    #      Deputies NATZHANG
    #      Description for regression
    #      Click on Save button
    #  Expected:
    #      A new project is created successfully
    #************************************************************
    ${ValidFrom}    Get Current Date    result_format=%d/%m/%Y
    Set Test Variable    ${ValidFrom}    ${ValidFrom}
    ${DeadLine}    Get Current Date    UTC    +10days    result_format=%d/%m/%Y
    ${ValidTo}    Get Current Date    UTC    +100days    result_format=%d/%m/%Y
    ${PROJECT}    Copy Dictionary    ${PROJECT_PARAM}
    Set To Dictionary    ${PROJECT}    
    ...    TENDER_ID=${G_TENDERID}    TENDER_TITLE=Regress    CUSTOEMR_NAME=Miele    CUSTOMER_LEVEL=Global
    ...   MODE=FCL    DEADLINE_TM_DATE=${DeadLine}    VALID_FROM=${ValidFrom}    VALID_TO=${ValidTo}    DEPUTY=NATZHANG
    Set Test Variable    ${PROJECT}    ${PROJECT}
    Create Project    ${PROJECT}

Step ${step} Check The Status Of This New Created Project
    #************************Step 3******************************
    #  Do:
    #      Check the Status of this new created project
    #  Expected:
    #      Status In Progress
    #      Pricing Round Number blank
    #      Pricing Round Status blank
    #************************************************************
    Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    In Progress  
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     ${EMPTY}
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    ${EMPTY}  

Step ${step} User Select The Row Which Project Name Is 20240815 FCL
    #************************Step 4******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks data cleaning button
    #  Expected:
    #      A dialogue named 20240815 FCL Regression shows
    #     successfully
    #************************************************************
    click    ${Project_toolbar_DataCleaningButton}
    Wait For Elements State    //h4[contains(text(),'${G_TENDERID}')]      visible    20
Step ${step} Click On Upload Button Select The Attachment To Upload
    #************************Step 5******************************
    #  Do:
    #      Click on Upload button select the attachment to upload
    #     index php attachments get adcf27a6 e3cf 4a5f aa62
    #     7a3521353c26
    #  Expected:
    #      Upload successfully
    #************************************************************
    Click    ${Data_toolbar_UploadButton}
    Wait For Elements State    ${Data_Upload_AddFile}    enabled    60
    ${Data_Upload_AddFile1}    Set Variable    xpath=//input[@name='file']
    Upload File By Selector    ${Data_Upload_AddFile1}    ${CURDIR}${/}TestData${/}TC12-FCLTemplate-Location-All.xlsx
    Wait For Elements State    xpath=//label[.='Document Name']    visible    30 


Step ${step} User Select Map Columns Like That
    #************************Step 6******************************
    #  Do:
    #      User select map columns like that
    #      Origin Country country from D
    #      Destination Country country to G
    #      Origin City city from C
    #      Destination City city to F
    #      Origin State state from E
    #      Destination State state to H
    #      Customer Lane ID Lane ID code B
    #      Origin Type Origin Type I
    #      Destination Type Des Type J
    #      Origin Postal Code Origin Postal Code K
    #      Destination Postal Code Destination Postal Code L
    #      Customer s Delivery Term Customer s Delivery Term M
    #      Customer Port of Load Customer Port of Load N
    #      Customer Port of Discharge Customer Port of Discharge O
    #      Volume Containers 20 Volume Containers 20 P
    #      Volume Containers 40 Volume Containers 40 Q
    #      Volume Containers 40HC Volume Containers 40HC R
    #      Volume Containers 45 Volume Containers 45 S
    #      Volume TEU Total Volume TEU Total T
    #      Commodity Description Commodity Description U
    #      Commodity Remarks Commodity Remarks W
    #      IMO Class IMO Class V
    #      IMO UN No IMO UN No W
    #      Click on Start button
    #  Expected:
    #      Step3
    #      Summary Successful
    #      Please close this page and go to Generate Internal
    #     Pricing Template
    #************************************************************
    Select Options By   ${Origin_Country}    label    ${SPACE}${SPACE}country from - D
    Select Options By   ${Destination_Country}     label      ${SPACE}${SPACE}country to - G
    Select Options By   ${Origin_City}    label     ${SPACE}city from - C
    Select Options By   ${Destination_City}    label      ${SPACE}${SPACE}city to - F
    Select Options By   ${FCL_Select_Origin_State}     label    State From - E
    Select Options By   ${FCL_Select_Destination_State}   label    State To - H
    Select Options By   ${Customer_Lane_ID}   label    Lane ID code - B
    Select Options By   ${FCL/AIR_Select_OriginType}       label   origin type - I
    Select Options By   ${FCL/AIR_Select_DestType}    label    des type - J
    Select Options By   ${FCL/AIR_Select_OriginPostalCode}     label    Origin Postal Code - K
    Select Options By   ${FCL/AIR_Select_DestiPostalCode}  label    Destination Postal Code - L
    Select Options By   ${Customer_Deliver_Term}    label    Customer's\nDelivery\nTerm - M
    Select Options By   ${Customer_Port_of_Load}    label       Customer Port of Load - N
    Select Options By   ${Customer_Port_of_Discharge}   label      Customer Port of Discharge - O
    Select Options By   ${Volume_Containers_20}    label    Volume\nContainers\n20 - P
    Select Options By   ${Volume_Containers_40}    label    Volume\nContainers\n40 - Q
    Select Options By   ${Volume_Containers_40HC}    label    Volume\nContainers\n40HC - R
    Select Options By   ${Volume_Containers_45}    label    Volume Containers 45 - S
    Select Options By   ${Volume_TEU_Total}    label    Volume\nTEU\nTota - T
    Select Options By   ${Commodity_Desc}    label    Commodity\nDescription - U
    Select Options By   ${IMO_Class}    label    IMO Class - V
    Select Options By   ${IMO_UN_No}      label    IMO UN No. - W
    # CLICK    ${FCL/AIR_CheckBox_OriginType}
    # CLICK    ${FCL/AIR_CheckBox_DestType} 
    # CLICK    ${FCL/AIR_CheckBox_OriginPostalCode}
    # CLICK    ${FCL/AIR_CheckBox_DestiPostalCode} 
    # CLICK    ${FCL_CheckBox_CustomerDelTerm} 
    # CLICK    ${FCL_CheckBox_CustomerPortofDischarge}
    # CLICK    ${FCL_CheckBox_CustomerPortofLoad}
    # click    ${FCL/AIR_CheckBox_CustomerLaneID}
    # click    ${FCL_CheckBox_VolumeCont20}    
    # click    ${FCL_CheckBox_VolumeCont40}     
    # click    ${FCL_CheckBox_VolumeCont40HC}    
    # click    ${FCL_CheckBox_VolumeCont45}    
    # click    ${FCL_CheckBox_VolumeTEUTotal}    
    # click    ${FCL_CheckBox_IMOClass}   
    # click    ${FCL_CheckBox_IMOUNNo}    
    click    ${Data_toolbar_StartButton}
    Wait For Elements State    ${Data_toolbar_DownloadButton}    visible    30 
    Wait For Elements State   ${Data_toolbar_UploadAfterStartButton}    visible
    Wait For Elements State    ${Data_toolbar_SetPassButton}     visible
    Wait Until Search Finished
    ${content}    Get Text    //div[@class="row form-group col-md-12 ng-scope"][2]
    Should Contain    ${content}    Summary: Successful
    Should Contain    ${content}    Please close this page and go to Generate Internal Pricing Template.


Step ${step} Close This Dialog
    #************************Step 7******************************
    #  Do:
    #      Close this dialog
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status In Progress
    #      Pricing Round Number blank
    #      Pricing Round Status blank
    #************************************************************
    CLICK    ${Data_toolbar_CloseButton}
    CLICK    [data-ng-click="onButtonClick(button)"]
    Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    In Progress  
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     ${EMPTY}
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    ${EMPTY}  


Step ${step} User Select The Row Which Project Name Is 20240815 FCL2
    #************************Step 8******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks template management button
    #      In the pop up dialog click on Start button in Step3
    #     upload with container type in the template management
    #     file upload it click on Skip button in step4
    #      And then click on Close button to Close this dialog
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status In Progress
    #      Pricing Round Number 1
    #      Pricing Round Status Not Started
    #************************************************************
    Click    ${Project_toolbar_TemplateManagementButton}
    Sleep    5
    click    [data-ng-click="generateInternalTemplate()"]
     Wait For Elements State    css=[data-ng-click="downloadGeneratedTemplate()"]    visible    30 
    ${filename}    Download File    css=[data-ng-click="downloadGeneratedTemplate()"]
#     ${file_path}    Get Download ZIP File Name    ${G_TENDERID}    .zip
#     click    css=[data-ng-click="downloadGeneratedTemplate()"]
#     Get Download ZIP File Name
#    ${file_path}     Get Download File Name    ${G_TENDERID}    .zip
#     ${file_path}    Get Download ZIP File Name    ${G_TENDERID}    .zip    css=[data-ng-click="downloadGeneratedTemplate()"]
#      ${DOWNLOAD_PATH}     Normalize Path    ${DOWNLOAD_PATH}
#     Extract Zip File    ${file_path}    ${DOWNLOAD_PATH}
#     ${FILES}    List Files In Directory   ${DOWNLOAD_PATH}   *.xlsx
#     ${excelFile}     Set Variable    ${DOWNLOAD_PATH}${/}${FILES}[0]
#     Set Test Variable    ${excelFile}    ${excelFile}
    Open Excel Document    ${filename}    FCL_D
    Write Excel Cell    5    89    20DC     FCL_D
    Write Excel Cell    6    89    20DC     FCL_D
    Save Excel Document   ${filename} 
    Close All Excel Documents    
    Reopen And Save Excel    ${filename} 
    Sleep    5
    click    [data-ng-click="uploadInternalPricingTemplate()"]
     Wait For Elements State   ${upload_addFileButton}     enabled
    Upload File By Selector    ${upload_addFileButton}    ${filename}
    click    ${Template_SkipSendToGPDButton}
    click    ${SkipSendToGPD_Yes}
    Wait For Elements State    css=[data-ng-click="go2NextStep()"]   enabled    20
    click   [data-ng-click="closeInternalTemplatePage()"]
    Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    In Progress  
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     1
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Not Started 

Step ${step} User Select The Row Which Project Name Is 20240815 FCL3
    #************************Step 9******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks round management button
    #      In the pop up dialog assign some users WENDJIAN to all
    #     the regions start round send notification
    #      And then click on Close button to Close this dialog
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status Active
    #      Pricing Round Number 1
    #      Pricing Round Status Started
    #************************************************************
     Click    ${Project_toolbar_RoundMgmtButton}
     Sleep    5
     Input Deadline In Region Tab    0    0
     Input Deadline In Region Tab    0    1
     Input Deadline In Region Tab    1    0
    CLICK    [data-ng-click="addUserToAssignment()"]
    Round Mgmt Assign User    //a[.='APAC']   xpath=//div[@data-model='availableItems']//ul//li//b[.='Wendy Jiang (WENDJIAN)']
    Round Mgmt Assign User    //a[.='EUROPE']   xpath=//div[@data-model='availableItems']//ul//li//b[.='Wendy Jiang (WENDJIAN)']
    Round Mgmt Assign User    //a[.='NAM']   xpath=//div[@data-model='availableItems']//ul//li//b[.='Wendy Jiang (WENDJIAN)']
    click    ${Project_RoundMgmt_Assign_SaveButton} 
    click    ${Project_RoundMgmt_StartButton} 
    click    ${Project_RoundMgmt_StartConfirmButton}
    click    ${Project_RoundMgmt_Confirm_SendButton}
    click    ${Project_RoundMgmt_CloseButton}
    Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Active 
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     1
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Started


Step ${step} User Select The Row Which Project Name Is 20240815 FCL4
    #************************Step 10******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks round management button
    #      In the pop up dialog Click Close Round do not send
    #     notification to anyone click on Yes
    #      And then click on Close button to Close this dialog
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status Active
    #      Pricing Round Number 1
    #      Pricing Round Status Closed
    #************************************************************
    Click    ${Project_toolbar_RoundMgmtButton}
     Sleep    5
     Input Deadline In Region Tab    0    0
     Input Deadline In Region Tab    0    1
     Input Deadline In Region Tab    1    0
    click    ${Project_RoundMgmt_CloseRoundButton} 
    click    ${Project_RoundMgmt_StartConfirmButton} 
    CLICK    ${Project_RoundMgmt_CloseButton}
    Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Active 
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     1
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Closed

Step ${step} User Select The Row Which Project Name Is 20240815 FCL5
    #************************Step 11******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks round management button
    #      In the pop up dialog Click New Round
    #      And then click on Close button to Close this dialog
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status Active
    #      Pricing Round Number 2
    #      Pricing Round Status Not Started
    #************************************************************
    Click    ${Project_toolbar_RoundMgmtButton}
     Sleep    5
     Input Deadline In Region Tab    0    0
     Input Deadline In Region Tab    0    1
     Input Deadline In Region Tab    1    0
    click    ${Project_RoundMgmt_NewRoundButton}
    click    [data-ng-click="onButtonClick(button)"]
    CLICK    ${Project_RoundMgmt_CloseButton}
     Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Active 
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     2
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Not Started

Step ${step} User Select The Row Which Project Name Is 20240815 FCL6
    #************************Step 12******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks round management button
    #      In the pop up dialog assign some users WENDJIAN to all
    #     the regions start round send notification close Round do
    #     not send notification to anyone click on Yes
    #      And then click on Close button to Close this dialog
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status Active
    #      Pricing Round Number 2
    #      Pricing Round Status Closed
    #************************************************************
    Click    ${Project_toolbar_RoundMgmtButton}
     Sleep    5
     Input Deadline In Region Tab    0    0
     Input Deadline In Region Tab    0    1
     Input Deadline In Region Tab    1    0
    click    ${Project_RoundMgmt_StartButton} 
    click    ${Project_RoundMgmt_StartConfirmButton}
    click    ${Project_RoundMgmt_Confirm_SendButton}
    click    ${Project_RoundMgmt_CloseRoundButton}
    click    ${Project_RoundMgmt_StartConfirmButton}
    # click   ${Project_RoundMgmt_StartConfirmButton}
    CLICK    ${Project_RoundMgmt_CloseButton}
     Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Active 
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     2
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Closed

Step ${step} User Select The Row Which Project Name Is 20240815 FCL7
    #************************Step 13******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks Submit Reactive button
    #      In the confirm window click on Yes
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status Submitted to Customer
    #      Pricing Round Number 2
    #      Pricing Round Status Closed
    #************************************************************
    click    ${Project_toolbar_Submit/ReactivateButton} 
    click    [data-ng-click="onButtonClick(button)"]
     Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Submitted to Customer 
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     2
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Closed



Step ${step} User Select The Row Which Project Name Is 20240815 FCL8
    #************************Step 14******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks Close Project button
    #  Expected:
    #      Failed with the error message Your tender cannot be
    #     closed until the award information has been uploaded for
    #     all lanes Please update your IPT accordingly and try
    #     again
    #************************************************************
    click    ${Project_toolbar_CloseButton}
    Wait Until Keyword Succeeds    10x    400ms    Get Page Source    contains        Your tender cannot be closed until the award information has been uploaded for all lanes. Please update your IPT accordingly and try again.
Step ${step} User Select The Row Which Project Name Is 20240815 FCL9
    #************************Step 15******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks Submit Reactive button
    #      In the confirm window click on Yes
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status Active
    #      Pricing Round Number 2
    #      Pricing Round Status Closed
    #************************************************************
    click    ${Project_toolbar_Submit/Reactivate Project}
    click    [data-ng-click="onButtonClick(button)"]
     Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Active
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     2
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Closed
Step ${step} User Select The Row Which Project Name Is 20240815 FCL10
    #************************Step 16******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks Lane Management button
    #      Update Existing Lanes
    #      Download the IPT update the value of DB Schenker
    #      Awarded Lane as following and then upload it
    #      index php attachments get 1000386644
    #  Expected:
    #      Successfully uploaded
    #************************************************************
    click    ${Project_toolbar_LaneManagementButton}
    Click If Enabled    ${Project_LaneMgmt_NextButton}
    ${filename}    Download File    ${Project_LaneMgmt_UpdateLane_DownloadButton} 
    Wait Until Search Finished
    Open Excel Document    ${filename}    FCL_D
    Write Excel Cell    5    7    N    FCL_D
    Write Excel Cell    6    7    N    FCL_D
    Save Excel Document   ${filename}
    Close All Excel Documents
    Reopen And Save Excel    ${filename} 
    click    ${Project_LaneMgmt_UpdateLane_UploadButton}
     Wait For Elements State   ${upload_addFileButton}     enabled
    Upload File By Selector    ${upload_addFileButton}    ${filename}
    CLICK    ${Project_LaneMgmt_UpdateLane_CloseButton} 

Step ${step} User Select The Row Which Project Name Is 20240815 FCL11
    #************************Step 17******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks Submit Reactive button
    #      In the confirm window click on Yes
    #      Refresh the current page of pricing project
    #      Check the Status of this new created project
    #  Expected:
    #      Status Submitted to Customer
    #      Pricing Round Number 2
    #      Pricing Round Status Closed
    #************************************************************
    Search Project    ${PROJECT.TENDER_ID}
    click    ${Project_toolbar_Submit/ReactivateButton} 
    click    [data-ng-click="onButtonClick(button)"]
     Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Submitted to Customer 
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     2
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Closed

Step ${step} User Select The Row Which Project Name Is 20240815 FCL12
    #************************Step 18******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks Close Project button
    #      In the confirm window click on Yes
    #      Search out this project by project name
    #      Check the Status of this new created project
    #  Expected:
    #      Status Closed
    #      Pricing Round Number 2
    #      Pricing Round Status Closed
    #************************************************************
    click    ${Project_toolbar_CloseButton}
    click    [data-ng-click="onButtonClick(button)"]
     Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Closed
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     2
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Closed

Step ${step} User Select The Row Which Project Name Is 20240815 FCL13
    #************************Step 19******************************
    #  Do:
    #      User select the row which project name is 20240815 FCL
    #     Regression clicks Reopen Project button
    #      In the confirm window click on Yes
    #      Search out this project by project name
    #      Check the Status of this new created project
    #  Expected:
    #      Status Active
    #      Pricing Round Number 2
    #      Pricing Round Status Closed
    #************************************************************
    click    ${Project_toolbar_ReopenProject}
    click    [data-ng-click="onButtonClick(button)"]
     Search Project    ${PROJECT.TENDER_ID}  
    ${Status}    get Text   //tr[@data-action-menu="action"]//td[7]  
    Should Be Equal    ${Status}    Active
    ${Pricing Round Number}    get Text   //tr[@data-action-menu="action"]//td[8]  
    Should Be Equal    ${Pricing Round Number}     2
    ${Pricing Round Status}    get Text   //tr[@data-action-menu="action"]//td[9]  
    Should Be Equal    ${Pricing Round Status}    Closed

Step ${step} User Click On Data Cleaning Of This Project And Then
    #************************Step 20******************************
    #  Do:
    #      User click on Data Cleaning of this project and then
    #     cancel it Delete this project
    #  Expected:
    #      The project can be deleted successfully
    #************************************************************
    click    ${Project_toolbar_DataCleaningButton}
    click    [data-ng-click="onButtonClick(button)"]
    CLICK    ${Data_toolbar_CloseButton}
    CLICK    [data-ng-click="onButtonClick(button)"]
    Search Project    ${PROJECT.TENDER_ID} 
Step ${step} User Goes To Basic Data Management Tender List2
    #************************Step 21******************************
    #  Do:
    #      User goes to Basic Data Management Tender List
    #      Search out the tender created in step1
    #      Click on Delete button
    #      Click on Yes button in the popup dialog
    #  Expected:
    #      System displays Tender has been deleted
    #************************************************************
    log    in tear down


